select distinct(area) from bd_business_description where city = 'Charlston' and state = 'London' and country = 'United Kingdom' AND status='1' and mirror=0 and area!='' order by city asc

You selected  Charlston, London, United Kingdom

Select another city

Select another city